Teradata Administrator Tool

Navigation

a) Start run

b) Start programs Teradata administrator Select TD Adminclick ok

i)Database creation:- clickyellow box

ii)Creating user click

iii)privileges

Teradata SQL

Sql IBM

PL/Sql ORACLE

T-SqlSQL Server

Tera data sql Tera data

• SQL is 4^th Generation language
• Fully based on set theory
• If contains a set of other languages for its operations

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

a) DDL - Data definition language

USE-For creating, ALTERING and REMOVING Objects

Commands-Creating, ALTERING, DROP

Note- There is no TRUNCATE COMMAND[delete entire at a time in oracle]

b) DML - Date Manipulation language

Use- For Manipulation objects data[By selecting, inserting, deleting, etc]

COMMAND- SELECT, INSERT,UPDATE, DELETE,MERGE

c) DCL - Date Control language

Use- For providing and revoking privileges for objects

COMMAND- GRANT, REVOKE, GIVE

SPL- Stored procedure language

Use: Creating and calling a stored procedure as procedures require concept c (or) c++ compilers we call this language as SPL

Teradata Extensions to SQL

• Help
• Show
• Explain
• Collect statistics

Show and Help commands

Show commands- It shows the DDL of the object

Syntax- Show object<object name>

Example- Show table<table name>

Show view<view name >

Show macro< macro name > etc…

Help command- It describes the objects by getting from the data dictionary

Syntax:- Help object<object name>

Help table< table name>

Help view < view name>

Help macro < macro name>

Help Procedure < Procedure name>

Help session To see session information etc..,

Teradata Interview Questions

Teradata objects

a) Table

b)Views

c)Macros

d)Triggers

e)Cursory

f)Procedure[Normal procedure(or) embedded (or) extended procedure]

CREATING Table

Create [SET/MULTISET][GLOBABL TEMPORARY/VOLATILE]

TABLE< TABLE  NAME>

<DATA OPTIONS>

<COLUMN DEFINITIONS>

<CONSTRAINTS>

<INDEXES>

SET TABLE- It does not allow complete row duplicate

FREE SPACE- The percentage of free memory Assigned from the cylindrical memory

MULTISET- It allows complete row duplicate

DATA BLOCK SIZE-The maximum data block size specified to the table at the time input, output of file system

DATA OPTIONS- FALL BACK, NO FALL BACK BEFORE JOURNAL, NO BEFORE JOURNAL AFTER JOURNAL, NO AFTER JOURNAL